{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from glob import glob\n",
    "from IPython.display import display\n",
    "pd.set_option('display.max_columns', 99)\n",
    "pd.set_option('display.max_rows', 99)\n",
    "import EDA\n",
    "import utils\n",
    "#sorted(glob('../data/*'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "100%|██████████| 20/20 [00:03<00:00,  5.65it/s]\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>SK_ID_BUREAU</th>\n",
       "      <th>CREDIT_ACTIVE</th>\n",
       "      <th>CREDIT_CURRENCY</th>\n",
       "      <th>DAYS_CREDIT</th>\n",
       "      <th>CREDIT_DAY_OVERDUE</th>\n",
       "      <th>DAYS_CREDIT_ENDDATE</th>\n",
       "      <th>DAYS_ENDDATE_FACT</th>\n",
       "      <th>AMT_CREDIT_MAX_OVERDUE</th>\n",
       "      <th>CNT_CREDIT_PROLONG</th>\n",
       "      <th>AMT_CREDIT_SUM</th>\n",
       "      <th>AMT_CREDIT_SUM_DEBT</th>\n",
       "      <th>AMT_CREDIT_SUM_LIMIT</th>\n",
       "      <th>AMT_CREDIT_SUM_OVERDUE</th>\n",
       "      <th>CREDIT_TYPE</th>\n",
       "      <th>DAYS_CREDIT_UPDATE</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "      <th>days_end-cre</th>\n",
       "      <th>days_fact-cre</th>\n",
       "      <th>days_fact-end</th>\n",
       "      <th>days_update-cre</th>\n",
       "      <th>days_update-end</th>\n",
       "      <th>days_update-fact</th>\n",
       "      <th>ant_cre-debt</th>\n",
       "      <th>ant_cre-debt-by-limit</th>\n",
       "      <th>ant_debt-p-limit</th>\n",
       "      <th>ant_cre-by-debt-p-limit</th>\n",
       "      <th>AMT_CREDIT_SUM-by-days_end-cre</th>\n",
       "      <th>AMT_CREDIT_SUM-by-days_fact-cre</th>\n",
       "      <th>AMT_CREDIT_SUM-by-days_fact-end</th>\n",
       "      <th>AMT_CREDIT_SUM-by-days_update-cre</th>\n",
       "      <th>AMT_CREDIT_SUM-by-days_update-end</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>248489</th>\n",
       "      <td>100001</td>\n",
       "      <td>5896635</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-49</td>\n",
       "      <td>0</td>\n",
       "      <td>1778.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>378000.0</td>\n",
       "      <td>373239.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-16</td>\n",
       "      <td>10822.5</td>\n",
       "      <td>1827.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33</td>\n",
       "      <td>-1794.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4761.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>373239.0</td>\n",
       "      <td>1.012756</td>\n",
       "      <td>206.896552</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11454.545455</td>\n",
       "      <td>-210.702341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248490</th>\n",
       "      <td>100001</td>\n",
       "      <td>5896636</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-320</td>\n",
       "      <td>0</td>\n",
       "      <td>411.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>168345.0</td>\n",
       "      <td>110281.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-10</td>\n",
       "      <td>9364.5</td>\n",
       "      <td>731.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>310</td>\n",
       "      <td>-421.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58063.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>230.294118</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>543.048387</td>\n",
       "      <td>-399.869359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248488</th>\n",
       "      <td>100001</td>\n",
       "      <td>5896634</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-559</td>\n",
       "      <td>0</td>\n",
       "      <td>902.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>337680.0</td>\n",
       "      <td>113166.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-6</td>\n",
       "      <td>4630.5</td>\n",
       "      <td>1461.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>553</td>\n",
       "      <td>-908.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>224514.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>113166.0</td>\n",
       "      <td>2.983935</td>\n",
       "      <td>231.129363</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>610.632911</td>\n",
       "      <td>-371.894273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248484</th>\n",
       "      <td>100001</td>\n",
       "      <td>5896630</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-857</td>\n",
       "      <td>0</td>\n",
       "      <td>-492.0</td>\n",
       "      <td>-553.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-155</td>\n",
       "      <td>0.0</td>\n",
       "      <td>365.0</td>\n",
       "      <td>304.0</td>\n",
       "      <td>-61.0</td>\n",
       "      <td>702</td>\n",
       "      <td>337.0</td>\n",
       "      <td>398.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>308.219178</td>\n",
       "      <td>370.065789</td>\n",
       "      <td>-1844.262295</td>\n",
       "      <td>160.256410</td>\n",
       "      <td>333.827893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248486</th>\n",
       "      <td>100001</td>\n",
       "      <td>5896632</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-879</td>\n",
       "      <td>0</td>\n",
       "      <td>-514.0</td>\n",
       "      <td>-544.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>91620.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-155</td>\n",
       "      <td>0.0</td>\n",
       "      <td>365.0</td>\n",
       "      <td>335.0</td>\n",
       "      <td>-30.0</td>\n",
       "      <td>724</td>\n",
       "      <td>359.0</td>\n",
       "      <td>389.0</td>\n",
       "      <td>91620.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>0.0</td>\n",
       "      <td>inf</td>\n",
       "      <td>251.013699</td>\n",
       "      <td>273.492537</td>\n",
       "      <td>-3054.000000</td>\n",
       "      <td>126.546961</td>\n",
       "      <td>255.208914</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        SK_ID_CURR  SK_ID_BUREAU CREDIT_ACTIVE CREDIT_CURRENCY  DAYS_CREDIT  \\\n",
       "248489      100001       5896635        Active      currency 1          -49   \n",
       "248490      100001       5896636        Active      currency 1         -320   \n",
       "248488      100001       5896634        Active      currency 1         -559   \n",
       "248484      100001       5896630        Closed      currency 1         -857   \n",
       "248486      100001       5896632        Closed      currency 1         -879   \n",
       "\n",
       "        CREDIT_DAY_OVERDUE  DAYS_CREDIT_ENDDATE  DAYS_ENDDATE_FACT  \\\n",
       "248489                   0               1778.0                NaN   \n",
       "248490                   0                411.0                NaN   \n",
       "248488                   0                902.0                NaN   \n",
       "248484                   0               -492.0             -553.0   \n",
       "248486                   0               -514.0             -544.0   \n",
       "\n",
       "        AMT_CREDIT_MAX_OVERDUE  CNT_CREDIT_PROLONG  AMT_CREDIT_SUM  \\\n",
       "248489                     NaN                   0        378000.0   \n",
       "248490                     NaN                   0        168345.0   \n",
       "248488                     NaN                   0        337680.0   \n",
       "248484                     NaN                   0        112500.0   \n",
       "248486                     NaN                   0         91620.0   \n",
       "\n",
       "        AMT_CREDIT_SUM_DEBT  AMT_CREDIT_SUM_LIMIT  AMT_CREDIT_SUM_OVERDUE  \\\n",
       "248489             373239.0                   0.0                     0.0   \n",
       "248490             110281.5                   NaN                     0.0   \n",
       "248488             113166.0                   0.0                     0.0   \n",
       "248484                  0.0                   0.0                     0.0   \n",
       "248486                  0.0                   0.0                     0.0   \n",
       "\n",
       "            CREDIT_TYPE  DAYS_CREDIT_UPDATE  AMT_ANNUITY  days_end-cre  \\\n",
       "248489  Consumer credit                 -16      10822.5        1827.0   \n",
       "248490  Consumer credit                 -10       9364.5         731.0   \n",
       "248488  Consumer credit                  -6       4630.5        1461.0   \n",
       "248484  Consumer credit                -155          0.0         365.0   \n",
       "248486  Consumer credit                -155          0.0         365.0   \n",
       "\n",
       "        days_fact-cre  days_fact-end  days_update-cre  days_update-end  \\\n",
       "248489            NaN            NaN               33          -1794.0   \n",
       "248490            NaN            NaN              310           -421.0   \n",
       "248488            NaN            NaN              553           -908.0   \n",
       "248484          304.0          -61.0              702            337.0   \n",
       "248486          335.0          -30.0              724            359.0   \n",
       "\n",
       "        days_update-fact  ant_cre-debt  ant_cre-debt-by-limit  \\\n",
       "248489               NaN        4761.0                    inf   \n",
       "248490               NaN       58063.5                    NaN   \n",
       "248488               NaN      224514.0                    inf   \n",
       "248484             398.0      112500.0                    inf   \n",
       "248486             389.0       91620.0                    inf   \n",
       "\n",
       "        ant_debt-p-limit  ant_cre-by-debt-p-limit  \\\n",
       "248489          373239.0                 1.012756   \n",
       "248490               NaN                      NaN   \n",
       "248488          113166.0                 2.983935   \n",
       "248484               0.0                      inf   \n",
       "248486               0.0                      inf   \n",
       "\n",
       "        AMT_CREDIT_SUM-by-days_end-cre  AMT_CREDIT_SUM-by-days_fact-cre  \\\n",
       "248489                      206.896552                              NaN   \n",
       "248490                      230.294118                              NaN   \n",
       "248488                      231.129363                              NaN   \n",
       "248484                      308.219178                       370.065789   \n",
       "248486                      251.013699                       273.492537   \n",
       "\n",
       "        AMT_CREDIT_SUM-by-days_fact-end  AMT_CREDIT_SUM-by-days_update-cre  \\\n",
       "248489                              NaN                       11454.545455   \n",
       "248490                              NaN                         543.048387   \n",
       "248488                              NaN                         610.632911   \n",
       "248484                     -1844.262295                         160.256410   \n",
       "248486                     -3054.000000                         126.546961   \n",
       "\n",
       "        AMT_CREDIT_SUM-by-days_update-end  \n",
       "248489                        -210.702341  \n",
       "248490                        -399.869359  \n",
       "248488                        -371.894273  \n",
       "248484                         333.827893  \n",
       "248486                         255.208914  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = utils.read_pickles('../data/bureau').sort_values(['SK_ID_CURR', 'DAYS_CREDIT'], ascending=[True, False])\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape: (1716428, 32)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>DataType</th>\n",
       "      <th>#Nulls</th>\n",
       "      <th>#Uniques</th>\n",
       "      <th>Min</th>\n",
       "      <th>Mean</th>\n",
       "      <th>Max</th>\n",
       "      <th>Std</th>\n",
       "      <th>top10 val</th>\n",
       "      <th>top10 cnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>305811</td>\n",
       "      <td>1.000010e+05</td>\n",
       "      <td>2.782149e+05</td>\n",
       "      <td>4.562550e+05</td>\n",
       "      <td>1.029386e+05</td>\n",
       "      <td>[120860, 169704, 318065, 251643, 425396, 29580...</td>\n",
       "      <td>[116, 94, 78, 61, 60, 59, 58, 57, 56, 55]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK_ID_BUREAU</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>1716428</td>\n",
       "      <td>5.000000e+06</td>\n",
       "      <td>5.924434e+06</td>\n",
       "      <td>6.843457e+06</td>\n",
       "      <td>5.322657e+05</td>\n",
       "      <td>[5000822, 6547158, 6487797, 6481654, 6483703, ...</td>\n",
       "      <td>[1, 1, 1, 1, 1, 1, 1, 1, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CREDIT_ACTIVE</th>\n",
       "      <td>object</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Closed', 'Active', 'Sold', 'Bad debt']</td>\n",
       "      <td>[1079273, 630607, 6527, 21]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CREDIT_CURRENCY</th>\n",
       "      <td>object</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['currency 1', 'currency 2', 'currency 3', 'cu...</td>\n",
       "      <td>[1715020, 1224, 174, 10]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAYS_CREDIT</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>2923</td>\n",
       "      <td>-2.922000e+03</td>\n",
       "      <td>-1.142108e+03</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.951649e+02</td>\n",
       "      <td>[-364, -336, -273, -357, -343, -315, -371, -36...</td>\n",
       "      <td>[1330, 1248, 1238, 1218, 1203, 1202, 1196, 119...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CREDIT_DAY_OVERDUE</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>942</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>8.181666e-01</td>\n",
       "      <td>2.792000e+03</td>\n",
       "      <td>3.654443e+01</td>\n",
       "      <td>[0, 30, 60, 13, 8, 9, 7, 14, 17, 11]</td>\n",
       "      <td>[1712211, 311, 126, 103, 103, 93, 92, 91, 77, 75]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAYS_CREDIT_ENDDATE</th>\n",
       "      <td>float64</td>\n",
       "      <td>105553</td>\n",
       "      <td>14096</td>\n",
       "      <td>-4.206000e+04</td>\n",
       "      <td>5.105174e+02</td>\n",
       "      <td>3.119900e+04</td>\n",
       "      <td>4.994220e+03</td>\n",
       "      <td>[0.0, 3.0, -7.0, 1.0, -14.0, -10.0, 4.0, -2.0,...</td>\n",
       "      <td>[883, 845, 837, 830, 787, 782, 777, 772, 771, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAYS_ENDDATE_FACT</th>\n",
       "      <td>float64</td>\n",
       "      <td>633653</td>\n",
       "      <td>2917</td>\n",
       "      <td>-4.202300e+04</td>\n",
       "      <td>-1.017437e+03</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>7.140106e+02</td>\n",
       "      <td>[-329.0, -273.0, -301.0, -91.0, -154.0, -84.0,...</td>\n",
       "      <td>[811, 794, 791, 785, 783, 783, 782, 778, 778, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_MAX_OVERDUE</th>\n",
       "      <td>float64</td>\n",
       "      <td>1124488</td>\n",
       "      <td>68251</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.825418e+03</td>\n",
       "      <td>1.159872e+08</td>\n",
       "      <td>2.060316e+05</td>\n",
       "      <td>[0.0, 1440.0, 225.0, 45.0, 4.5, 90.0, 4500.0, ...</td>\n",
       "      <td>[470650, 688, 405, 377, 315, 222, 220, 192, 19...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CNT_CREDIT_PROLONG</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6.410406e-03</td>\n",
       "      <td>9.000000e+00</td>\n",
       "      <td>9.622391e-02</td>\n",
       "      <td>[0, 1, 2, 3, 4, 5, 9, 6, 8, 7]</td>\n",
       "      <td>[1707314, 7620, 1222, 191, 54, 21, 2, 2, 1, 1]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM</th>\n",
       "      <td>float64</td>\n",
       "      <td>13</td>\n",
       "      <td>236708</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.549946e+05</td>\n",
       "      <td>5.850000e+08</td>\n",
       "      <td>1.149811e+06</td>\n",
       "      <td>[0.0, 225000.0, 135000.0, 450000.0, 90000.0, 1...</td>\n",
       "      <td>[66582, 57608, 50195, 37156, 36940, 28840, 265...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM_DEBT</th>\n",
       "      <td>float64</td>\n",
       "      <td>257669</td>\n",
       "      <td>226537</td>\n",
       "      <td>-4.705600e+06</td>\n",
       "      <td>1.370851e+05</td>\n",
       "      <td>1.701000e+08</td>\n",
       "      <td>6.774011e+05</td>\n",
       "      <td>[0.0, 4.5, -450.0, 135000.0, 90000.0, 45000.0,...</td>\n",
       "      <td>[1016434, 653, 543, 344, 320, 316, 307, 238, 2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM_LIMIT</th>\n",
       "      <td>float64</td>\n",
       "      <td>591780</td>\n",
       "      <td>51726</td>\n",
       "      <td>-5.864061e+05</td>\n",
       "      <td>6.229515e+03</td>\n",
       "      <td>4.705600e+06</td>\n",
       "      <td>4.503203e+04</td>\n",
       "      <td>[0.0, 135000.0, 4500.0, 45000.0, 90000.0, 1350...</td>\n",
       "      <td>[1050142, 2178, 1474, 1335, 974, 833, 766, 757...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM_OVERDUE</th>\n",
       "      <td>float64</td>\n",
       "      <td>0</td>\n",
       "      <td>1616</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3.791276e+01</td>\n",
       "      <td>3.756681e+06</td>\n",
       "      <td>5.937650e+03</td>\n",
       "      <td>[0.0, 4.5, 9.0, 13.5, 18.0, 22.5, 45.0, 27.0, ...</td>\n",
       "      <td>[1712270, 301, 107, 81, 72, 60, 56, 52, 50, 48]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CREDIT_TYPE</th>\n",
       "      <td>object</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>['Consumer credit', 'Credit card', 'Car loan',...</td>\n",
       "      <td>[1251615, 402195, 27690, 18391, 12413, 1975, 1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DAYS_CREDIT_UPDATE</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>2982</td>\n",
       "      <td>-4.194700e+04</td>\n",
       "      <td>-5.937483e+02</td>\n",
       "      <td>3.720000e+02</td>\n",
       "      <td>7.207473e+02</td>\n",
       "      <td>[-7, -8, -11, -15, -12, -10, -9, -13, -6, -14]</td>\n",
       "      <td>[18503, 18462, 16975, 16870, 16827, 16651, 165...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "      <td>float64</td>\n",
       "      <td>1226791</td>\n",
       "      <td>40321</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.571276e+04</td>\n",
       "      <td>1.184534e+08</td>\n",
       "      <td>3.258269e+05</td>\n",
       "      <td>[0.0, 4500.0, 13500.0, 22500.0, 9000.0, 18000....</td>\n",
       "      <td>[256915, 5182, 3147, 2502, 1725, 1605, 1593, 1...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>days_end-cre</th>\n",
       "      <td>float64</td>\n",
       "      <td>105553</td>\n",
       "      <td>11891</td>\n",
       "      <td>-4.179000e+04</td>\n",
       "      <td>1.676274e+03</td>\n",
       "      <td>3.410500e+04</td>\n",
       "      <td>4.876388e+03</td>\n",
       "      <td>[1826.0, 365.0, 1096.0, 731.0, 366.0, 730.0, 1...</td>\n",
       "      <td>[119578, 89849, 73964, 41051, 40486, 38273, 36...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>days_fact-cre</th>\n",
       "      <td>float64</td>\n",
       "      <td>633653</td>\n",
       "      <td>2710</td>\n",
       "      <td>-3.968300e+04</td>\n",
       "      <td>3.994822e+02</td>\n",
       "      <td>2.877000e+03</td>\n",
       "      <td>3.720605e+02</td>\n",
       "      <td>[365.0, 184.0, 183.0, 306.0, 304.0, 366.0, 182...</td>\n",
       "      <td>[23274, 23197, 19464, 16186, 14630, 14618, 137...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>days_fact-end</th>\n",
       "      <td>float64</td>\n",
       "      <td>666442</td>\n",
       "      <td>10536</td>\n",
       "      <td>-4.018700e+04</td>\n",
       "      <td>-4.630359e+02</td>\n",
       "      <td>4.169200e+04</td>\n",
       "      <td>2.870530e+03</td>\n",
       "      <td>[0.0, 1.0, -29.0, -28.0, 2.0, 3.0, -59.0, 4.0,...</td>\n",
       "      <td>[323837, 34750, 33090, 22554, 12620, 11206, 87...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>days_update-cre</th>\n",
       "      <td>int64</td>\n",
       "      <td>0</td>\n",
       "      <td>3013</td>\n",
       "      <td>-4.164600e+04</td>\n",
       "      <td>5.483594e+02</td>\n",
       "      <td>2.927000e+03</td>\n",
       "      <td>6.018939e+02</td>\n",
       "      <td>[184, 185, 306, 186, 183, 367, 365, 0, 366, 307]</td>\n",
       "      <td>[14013, 11587, 11177, 11095, 10836, 9850, 9514...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>days_update-end</th>\n",
       "      <td>float64</td>\n",
       "      <td>105553</td>\n",
       "      <td>14441</td>\n",
       "      <td>-4.274200e+04</td>\n",
       "      <td>-1.127743e+03</td>\n",
       "      <td>4.204300e+04</td>\n",
       "      <td>4.864286e+03</td>\n",
       "      <td>[0.0, 6.0, 2.0, 1.0, 3.0, 5.0, 4.0, -29.0, -28...</td>\n",
       "      <td>[97514, 36644, 31959, 30331, 26538, 24661, 243...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>days_update-fact</th>\n",
       "      <td>float64</td>\n",
       "      <td>633653</td>\n",
       "      <td>3222</td>\n",
       "      <td>-4.165700e+04</td>\n",
       "      <td>1.615812e+02</td>\n",
       "      <td>3.982700e+04</td>\n",
       "      <td>5.100240e+02</td>\n",
       "      <td>[0.0, 3.0, 1.0, 2.0, 6.0, 4.0, 5.0, 7.0, 8.0, ...</td>\n",
       "      <td>[310485, 82074, 63453, 62402, 49411, 35847, 35...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ant_cre-debt</th>\n",
       "      <td>float64</td>\n",
       "      <td>257682</td>\n",
       "      <td>317264</td>\n",
       "      <td>-3.962804e+07</td>\n",
       "      <td>2.019430e+05</td>\n",
       "      <td>3.960000e+08</td>\n",
       "      <td>7.510985e+05</td>\n",
       "      <td>[0.0, 225000.0, 135000.0, 450000.0, 90000.0, 4...</td>\n",
       "      <td>[69881, 27971, 26517, 17080, 16121, 15981, 140...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ant_cre-debt-by-limit</th>\n",
       "      <td>float64</td>\n",
       "      <td>651970</td>\n",
       "      <td>27638</td>\n",
       "      <td>-inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[inf, 1.0, -inf, 1.0000000000000002, 0.9999999...</td>\n",
       "      <td>[971404, 35551, 18648, 1902, 843, 828, 828, 47...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ant_debt-p-limit</th>\n",
       "      <td>float64</td>\n",
       "      <td>591880</td>\n",
       "      <td>184704</td>\n",
       "      <td>-4.484634e+05</td>\n",
       "      <td>1.478107e+05</td>\n",
       "      <td>6.544140e+07</td>\n",
       "      <td>6.636866e+05</td>\n",
       "      <td>[0.0, 135000.0, 90000.0, 45000.0, 225000.0, 45...</td>\n",
       "      <td>[747860, 6049, 3319, 3272, 2700, 2502, 2265, 2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ant_cre-by-debt-p-limit</th>\n",
       "      <td>float64</td>\n",
       "      <td>643885</td>\n",
       "      <td>264021</td>\n",
       "      <td>-1.003426e-02</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[inf, 1.0, 0.0, 0.5454545454545454, 2.0, 0.980...</td>\n",
       "      <td>[695855, 54504, 1325, 441, 218, 206, 180, 157,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM-by-days_end-cre</th>\n",
       "      <td>float64</td>\n",
       "      <td>106135</td>\n",
       "      <td>681140</td>\n",
       "      <td>-5.625000e+05</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[0.0, 616.4383561643835, 410.5839416058394, 36...</td>\n",
       "      <td>[56017, 5670, 5366, 4930, 4855, 4553, 4488, 44...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM-by-days_fact-cre</th>\n",
       "      <td>float64</td>\n",
       "      <td>634242</td>\n",
       "      <td>624906</td>\n",
       "      <td>-1.046512e+04</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[0.0, inf, 1500.0, 2250.0, 368.8524590163934, ...</td>\n",
       "      <td>[29593, 1436, 1131, 1059, 968, 944, 932, 841, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM-by-days_fact-end</th>\n",
       "      <td>float64</td>\n",
       "      <td>670209</td>\n",
       "      <td>422735</td>\n",
       "      <td>-2.812500e+07</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[inf, -0.0, 45000.0, 13500.0, 135000.0, 225000...</td>\n",
       "      <td>[320070, 21218, 1491, 1460, 1084, 1062, 1059, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM-by-days_update-cre</th>\n",
       "      <td>float64</td>\n",
       "      <td>1116</td>\n",
       "      <td>887718</td>\n",
       "      <td>-9.729711e+06</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[0.0, inf, 90000.0, 2250.0, 1125.0, 1500.0, 45...</td>\n",
       "      <td>[65479, 8271, 1432, 1306, 1253, 1246, 1194, 11...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AMT_CREDIT_SUM-by-days_update-end</th>\n",
       "      <td>float64</td>\n",
       "      <td>107168</td>\n",
       "      <td>829594</td>\n",
       "      <td>-2.812500e+07</td>\n",
       "      <td>inf</td>\n",
       "      <td>inf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[inf, 0.0, 45000.0, 22500.0, 11250.0, 90000.0,...</td>\n",
       "      <td>[95903, 54984, 2238, 2055, 1253, 1250, 1119, 1...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  DataType   #Nulls  #Uniques           Min  \\\n",
       "SK_ID_CURR                           int64        0    305811  1.000010e+05   \n",
       "SK_ID_BUREAU                         int64        0   1716428  5.000000e+06   \n",
       "CREDIT_ACTIVE                       object        0         4           NaN   \n",
       "CREDIT_CURRENCY                     object        0         4           NaN   \n",
       "DAYS_CREDIT                          int64        0      2923 -2.922000e+03   \n",
       "CREDIT_DAY_OVERDUE                   int64        0       942  0.000000e+00   \n",
       "DAYS_CREDIT_ENDDATE                float64   105553     14096 -4.206000e+04   \n",
       "DAYS_ENDDATE_FACT                  float64   633653      2917 -4.202300e+04   \n",
       "AMT_CREDIT_MAX_OVERDUE             float64  1124488     68251  0.000000e+00   \n",
       "CNT_CREDIT_PROLONG                   int64        0        10  0.000000e+00   \n",
       "AMT_CREDIT_SUM                     float64       13    236708  0.000000e+00   \n",
       "AMT_CREDIT_SUM_DEBT                float64   257669    226537 -4.705600e+06   \n",
       "AMT_CREDIT_SUM_LIMIT               float64   591780     51726 -5.864061e+05   \n",
       "AMT_CREDIT_SUM_OVERDUE             float64        0      1616  0.000000e+00   \n",
       "CREDIT_TYPE                         object        0        15           NaN   \n",
       "DAYS_CREDIT_UPDATE                   int64        0      2982 -4.194700e+04   \n",
       "AMT_ANNUITY                        float64  1226791     40321  0.000000e+00   \n",
       "days_end-cre                       float64   105553     11891 -4.179000e+04   \n",
       "days_fact-cre                      float64   633653      2710 -3.968300e+04   \n",
       "days_fact-end                      float64   666442     10536 -4.018700e+04   \n",
       "days_update-cre                      int64        0      3013 -4.164600e+04   \n",
       "days_update-end                    float64   105553     14441 -4.274200e+04   \n",
       "days_update-fact                   float64   633653      3222 -4.165700e+04   \n",
       "ant_cre-debt                       float64   257682    317264 -3.962804e+07   \n",
       "ant_cre-debt-by-limit              float64   651970     27638          -inf   \n",
       "ant_debt-p-limit                   float64   591880    184704 -4.484634e+05   \n",
       "ant_cre-by-debt-p-limit            float64   643885    264021 -1.003426e-02   \n",
       "AMT_CREDIT_SUM-by-days_end-cre     float64   106135    681140 -5.625000e+05   \n",
       "AMT_CREDIT_SUM-by-days_fact-cre    float64   634242    624906 -1.046512e+04   \n",
       "AMT_CREDIT_SUM-by-days_fact-end    float64   670209    422735 -2.812500e+07   \n",
       "AMT_CREDIT_SUM-by-days_update-cre  float64     1116    887718 -9.729711e+06   \n",
       "AMT_CREDIT_SUM-by-days_update-end  float64   107168    829594 -2.812500e+07   \n",
       "\n",
       "                                           Mean           Max           Std  \\\n",
       "SK_ID_CURR                         2.782149e+05  4.562550e+05  1.029386e+05   \n",
       "SK_ID_BUREAU                       5.924434e+06  6.843457e+06  5.322657e+05   \n",
       "CREDIT_ACTIVE                               NaN           NaN           NaN   \n",
       "CREDIT_CURRENCY                             NaN           NaN           NaN   \n",
       "DAYS_CREDIT                       -1.142108e+03  0.000000e+00  7.951649e+02   \n",
       "CREDIT_DAY_OVERDUE                 8.181666e-01  2.792000e+03  3.654443e+01   \n",
       "DAYS_CREDIT_ENDDATE                5.105174e+02  3.119900e+04  4.994220e+03   \n",
       "DAYS_ENDDATE_FACT                 -1.017437e+03  0.000000e+00  7.140106e+02   \n",
       "AMT_CREDIT_MAX_OVERDUE             3.825418e+03  1.159872e+08  2.060316e+05   \n",
       "CNT_CREDIT_PROLONG                 6.410406e-03  9.000000e+00  9.622391e-02   \n",
       "AMT_CREDIT_SUM                     3.549946e+05  5.850000e+08  1.149811e+06   \n",
       "AMT_CREDIT_SUM_DEBT                1.370851e+05  1.701000e+08  6.774011e+05   \n",
       "AMT_CREDIT_SUM_LIMIT               6.229515e+03  4.705600e+06  4.503203e+04   \n",
       "AMT_CREDIT_SUM_OVERDUE             3.791276e+01  3.756681e+06  5.937650e+03   \n",
       "CREDIT_TYPE                                 NaN           NaN           NaN   \n",
       "DAYS_CREDIT_UPDATE                -5.937483e+02  3.720000e+02  7.207473e+02   \n",
       "AMT_ANNUITY                        1.571276e+04  1.184534e+08  3.258269e+05   \n",
       "days_end-cre                       1.676274e+03  3.410500e+04  4.876388e+03   \n",
       "days_fact-cre                      3.994822e+02  2.877000e+03  3.720605e+02   \n",
       "days_fact-end                     -4.630359e+02  4.169200e+04  2.870530e+03   \n",
       "days_update-cre                    5.483594e+02  2.927000e+03  6.018939e+02   \n",
       "days_update-end                   -1.127743e+03  4.204300e+04  4.864286e+03   \n",
       "days_update-fact                   1.615812e+02  3.982700e+04  5.100240e+02   \n",
       "ant_cre-debt                       2.019430e+05  3.960000e+08  7.510985e+05   \n",
       "ant_cre-debt-by-limit                       NaN           inf           NaN   \n",
       "ant_debt-p-limit                   1.478107e+05  6.544140e+07  6.636866e+05   \n",
       "ant_cre-by-debt-p-limit                     inf           inf           NaN   \n",
       "AMT_CREDIT_SUM-by-days_end-cre              inf           inf           NaN   \n",
       "AMT_CREDIT_SUM-by-days_fact-cre             inf           inf           NaN   \n",
       "AMT_CREDIT_SUM-by-days_fact-end             inf           inf           NaN   \n",
       "AMT_CREDIT_SUM-by-days_update-cre           inf           inf           NaN   \n",
       "AMT_CREDIT_SUM-by-days_update-end           inf           inf           NaN   \n",
       "\n",
       "                                                                           top10 val  \\\n",
       "SK_ID_CURR                         [120860, 169704, 318065, 251643, 425396, 29580...   \n",
       "SK_ID_BUREAU                       [5000822, 6547158, 6487797, 6481654, 6483703, ...   \n",
       "CREDIT_ACTIVE                               ['Closed', 'Active', 'Sold', 'Bad debt']   \n",
       "CREDIT_CURRENCY                    ['currency 1', 'currency 2', 'currency 3', 'cu...   \n",
       "DAYS_CREDIT                        [-364, -336, -273, -357, -343, -315, -371, -36...   \n",
       "CREDIT_DAY_OVERDUE                              [0, 30, 60, 13, 8, 9, 7, 14, 17, 11]   \n",
       "DAYS_CREDIT_ENDDATE                [0.0, 3.0, -7.0, 1.0, -14.0, -10.0, 4.0, -2.0,...   \n",
       "DAYS_ENDDATE_FACT                  [-329.0, -273.0, -301.0, -91.0, -154.0, -84.0,...   \n",
       "AMT_CREDIT_MAX_OVERDUE             [0.0, 1440.0, 225.0, 45.0, 4.5, 90.0, 4500.0, ...   \n",
       "CNT_CREDIT_PROLONG                                    [0, 1, 2, 3, 4, 5, 9, 6, 8, 7]   \n",
       "AMT_CREDIT_SUM                     [0.0, 225000.0, 135000.0, 450000.0, 90000.0, 1...   \n",
       "AMT_CREDIT_SUM_DEBT                [0.0, 4.5, -450.0, 135000.0, 90000.0, 45000.0,...   \n",
       "AMT_CREDIT_SUM_LIMIT               [0.0, 135000.0, 4500.0, 45000.0, 90000.0, 1350...   \n",
       "AMT_CREDIT_SUM_OVERDUE             [0.0, 4.5, 9.0, 13.5, 18.0, 22.5, 45.0, 27.0, ...   \n",
       "CREDIT_TYPE                        ['Consumer credit', 'Credit card', 'Car loan',...   \n",
       "DAYS_CREDIT_UPDATE                    [-7, -8, -11, -15, -12, -10, -9, -13, -6, -14]   \n",
       "AMT_ANNUITY                        [0.0, 4500.0, 13500.0, 22500.0, 9000.0, 18000....   \n",
       "days_end-cre                       [1826.0, 365.0, 1096.0, 731.0, 366.0, 730.0, 1...   \n",
       "days_fact-cre                      [365.0, 184.0, 183.0, 306.0, 304.0, 366.0, 182...   \n",
       "days_fact-end                      [0.0, 1.0, -29.0, -28.0, 2.0, 3.0, -59.0, 4.0,...   \n",
       "days_update-cre                     [184, 185, 306, 186, 183, 367, 365, 0, 366, 307]   \n",
       "days_update-end                    [0.0, 6.0, 2.0, 1.0, 3.0, 5.0, 4.0, -29.0, -28...   \n",
       "days_update-fact                   [0.0, 3.0, 1.0, 2.0, 6.0, 4.0, 5.0, 7.0, 8.0, ...   \n",
       "ant_cre-debt                       [0.0, 225000.0, 135000.0, 450000.0, 90000.0, 4...   \n",
       "ant_cre-debt-by-limit              [inf, 1.0, -inf, 1.0000000000000002, 0.9999999...   \n",
       "ant_debt-p-limit                   [0.0, 135000.0, 90000.0, 45000.0, 225000.0, 45...   \n",
       "ant_cre-by-debt-p-limit            [inf, 1.0, 0.0, 0.5454545454545454, 2.0, 0.980...   \n",
       "AMT_CREDIT_SUM-by-days_end-cre     [0.0, 616.4383561643835, 410.5839416058394, 36...   \n",
       "AMT_CREDIT_SUM-by-days_fact-cre    [0.0, inf, 1500.0, 2250.0, 368.8524590163934, ...   \n",
       "AMT_CREDIT_SUM-by-days_fact-end    [inf, -0.0, 45000.0, 13500.0, 135000.0, 225000...   \n",
       "AMT_CREDIT_SUM-by-days_update-cre  [0.0, inf, 90000.0, 2250.0, 1125.0, 1500.0, 45...   \n",
       "AMT_CREDIT_SUM-by-days_update-end  [inf, 0.0, 45000.0, 22500.0, 11250.0, 90000.0,...   \n",
       "\n",
       "                                                                           top10 cnt  \n",
       "SK_ID_CURR                                 [116, 94, 78, 61, 60, 59, 58, 57, 56, 55]  \n",
       "SK_ID_BUREAU                                          [1, 1, 1, 1, 1, 1, 1, 1, 1, 1]  \n",
       "CREDIT_ACTIVE                                            [1079273, 630607, 6527, 21]  \n",
       "CREDIT_CURRENCY                                             [1715020, 1224, 174, 10]  \n",
       "DAYS_CREDIT                        [1330, 1248, 1238, 1218, 1203, 1202, 1196, 119...  \n",
       "CREDIT_DAY_OVERDUE                 [1712211, 311, 126, 103, 103, 93, 92, 91, 77, 75]  \n",
       "DAYS_CREDIT_ENDDATE                [883, 845, 837, 830, 787, 782, 777, 772, 771, ...  \n",
       "DAYS_ENDDATE_FACT                  [811, 794, 791, 785, 783, 783, 782, 778, 778, ...  \n",
       "AMT_CREDIT_MAX_OVERDUE             [470650, 688, 405, 377, 315, 222, 220, 192, 19...  \n",
       "CNT_CREDIT_PROLONG                    [1707314, 7620, 1222, 191, 54, 21, 2, 2, 1, 1]  \n",
       "AMT_CREDIT_SUM                     [66582, 57608, 50195, 37156, 36940, 28840, 265...  \n",
       "AMT_CREDIT_SUM_DEBT                [1016434, 653, 543, 344, 320, 316, 307, 238, 2...  \n",
       "AMT_CREDIT_SUM_LIMIT               [1050142, 2178, 1474, 1335, 974, 833, 766, 757...  \n",
       "AMT_CREDIT_SUM_OVERDUE               [1712270, 301, 107, 81, 72, 60, 56, 52, 50, 48]  \n",
       "CREDIT_TYPE                        [1251615, 402195, 27690, 18391, 12413, 1975, 1...  \n",
       "DAYS_CREDIT_UPDATE                 [18503, 18462, 16975, 16870, 16827, 16651, 165...  \n",
       "AMT_ANNUITY                        [256915, 5182, 3147, 2502, 1725, 1605, 1593, 1...  \n",
       "days_end-cre                       [119578, 89849, 73964, 41051, 40486, 38273, 36...  \n",
       "days_fact-cre                      [23274, 23197, 19464, 16186, 14630, 14618, 137...  \n",
       "days_fact-end                      [323837, 34750, 33090, 22554, 12620, 11206, 87...  \n",
       "days_update-cre                    [14013, 11587, 11177, 11095, 10836, 9850, 9514...  \n",
       "days_update-end                    [97514, 36644, 31959, 30331, 26538, 24661, 243...  \n",
       "days_update-fact                   [310485, 82074, 63453, 62402, 49411, 35847, 35...  \n",
       "ant_cre-debt                       [69881, 27971, 26517, 17080, 16121, 15981, 140...  \n",
       "ant_cre-debt-by-limit              [971404, 35551, 18648, 1902, 843, 828, 828, 47...  \n",
       "ant_debt-p-limit                   [747860, 6049, 3319, 3272, 2700, 2502, 2265, 2...  \n",
       "ant_cre-by-debt-p-limit            [695855, 54504, 1325, 441, 218, 206, 180, 157,...  \n",
       "AMT_CREDIT_SUM-by-days_end-cre     [56017, 5670, 5366, 4930, 4855, 4553, 4488, 44...  \n",
       "AMT_CREDIT_SUM-by-days_fact-cre    [29593, 1436, 1131, 1059, 968, 944, 932, 841, ...  \n",
       "AMT_CREDIT_SUM-by-days_fact-end    [320070, 21218, 1491, 1460, 1084, 1062, 1059, ...  \n",
       "AMT_CREDIT_SUM-by-days_update-cre  [65479, 8271, 1432, 1306, 1253, 1246, 1194, 11...  \n",
       "AMT_CREDIT_SUM-by-days_update-end  [95903, 54984, 2238, 2055, 1253, 1250, 1119, 1...  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "EDA.df_info(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['SK_ID_CURR', 'SK_ID_BUREAU', 'CREDIT_ACTIVE', 'CREDIT_CURRENCY',\n",
       "       'DAYS_CREDIT', 'CREDIT_DAY_OVERDUE', 'DAYS_CREDIT_ENDDATE',\n",
       "       'DAYS_ENDDATE_FACT', 'AMT_CREDIT_MAX_OVERDUE', 'CNT_CREDIT_PROLONG',\n",
       "       'AMT_CREDIT_SUM', 'AMT_CREDIT_SUM_DEBT', 'AMT_CREDIT_SUM_LIMIT',\n",
       "       'AMT_CREDIT_SUM_OVERDUE', 'CREDIT_TYPE', 'DAYS_CREDIT_UPDATE',\n",
       "       'AMT_ANNUITY', 'days_end-cre', 'days_fact-cre', 'days_fact-end',\n",
       "       'days_update-cre', 'days_update-end', 'days_update-fact',\n",
       "       'ant_cre-debt', 'ant_cre-debt-by-limit', 'ant_debt-p-limit',\n",
       "       'ant_cre-by-debt-p-limit', 'AMT_CREDIT_SUM-by-days_end-cre',\n",
       "       'AMT_CREDIT_SUM-by-days_fact-cre', 'AMT_CREDIT_SUM-by-days_fact-end',\n",
       "       'AMT_CREDIT_SUM-by-days_update-cre',\n",
       "       'AMT_CREDIT_SUM-by-days_update-end'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "ids = df.SK_ID_CURR.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>SK_ID_BUREAU</th>\n",
       "      <th>CREDIT_ACTIVE</th>\n",
       "      <th>CREDIT_CURRENCY</th>\n",
       "      <th>DAYS_CREDIT</th>\n",
       "      <th>CREDIT_DAY_OVERDUE</th>\n",
       "      <th>DAYS_CREDIT_ENDDATE</th>\n",
       "      <th>DAYS_ENDDATE_FACT</th>\n",
       "      <th>AMT_CREDIT_MAX_OVERDUE</th>\n",
       "      <th>CNT_CREDIT_PROLONG</th>\n",
       "      <th>AMT_CREDIT_SUM</th>\n",
       "      <th>AMT_CREDIT_SUM_DEBT</th>\n",
       "      <th>AMT_CREDIT_SUM_LIMIT</th>\n",
       "      <th>AMT_CREDIT_SUM_OVERDUE</th>\n",
       "      <th>CREDIT_TYPE</th>\n",
       "      <th>DAYS_CREDIT_UPDATE</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1439216</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693683</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-235</td>\n",
       "      <td>0</td>\n",
       "      <td>863.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.237500e+06</td>\n",
       "      <td>1095934.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-48</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439206</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693672</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-316</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>9.067050e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-232</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439209</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693675</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-362</td>\n",
       "      <td>0</td>\n",
       "      <td>1464.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.452500e+06</td>\n",
       "      <td>1871662.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-61</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439205</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693671</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-366</td>\n",
       "      <td>0</td>\n",
       "      <td>730.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.250000e+05</td>\n",
       "      <td>-450.000</td>\n",
       "      <td>225450.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-232</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1695342</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693670</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-420</td>\n",
       "      <td>0</td>\n",
       "      <td>-145.0</td>\n",
       "      <td>-356.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>7.650000e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-332</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439215</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693682</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-465</td>\n",
       "      <td>0</td>\n",
       "      <td>-373.0</td>\n",
       "      <td>-373.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.141819e+05</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-370</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439207</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693673</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-508</td>\n",
       "      <td>0</td>\n",
       "      <td>1318.0</td>\n",
       "      <td>-351.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1.107000e+06</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-334</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1695343</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693681</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-594</td>\n",
       "      <td>0</td>\n",
       "      <td>228.0</td>\n",
       "      <td>-380.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.645000e+05</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-376</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439208</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693674</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1082</td>\n",
       "      <td>0</td>\n",
       "      <td>-351.0</td>\n",
       "      <td>-381.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1.538550e+05</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-381</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439212</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693678</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1685</td>\n",
       "      <td>0</td>\n",
       "      <td>-1501.0</td>\n",
       "      <td>-1085.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>5.079600e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1085</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439211</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693677</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2293</td>\n",
       "      <td>0</td>\n",
       "      <td>-1928.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4.500000e+04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1935</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439213</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693679</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2371</td>\n",
       "      <td>0</td>\n",
       "      <td>225.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6.300000e+05</td>\n",
       "      <td>586111.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-26</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439214</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693680</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2373</td>\n",
       "      <td>0</td>\n",
       "      <td>-566.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6.300000e+05</td>\n",
       "      <td>511164.000</td>\n",
       "      <td>43888.500</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-26</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1439210</th>\n",
       "      <td>172665</td>\n",
       "      <td>6693676</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2553</td>\n",
       "      <td>0</td>\n",
       "      <td>-2201.0</td>\n",
       "      <td>-2187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.636550e+04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2187</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325465</th>\n",
       "      <td>201208</td>\n",
       "      <td>5537173</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-387</td>\n",
       "      <td>0</td>\n",
       "      <td>711.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.700000e+05</td>\n",
       "      <td>194998.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-55</td>\n",
       "      <td>7297.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325466</th>\n",
       "      <td>201208</td>\n",
       "      <td>5537174</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-925</td>\n",
       "      <td>0</td>\n",
       "      <td>-743.0</td>\n",
       "      <td>-743.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.523500e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-737</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368454</th>\n",
       "      <td>201208</td>\n",
       "      <td>5537175</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1471</td>\n",
       "      <td>0</td>\n",
       "      <td>-402.0</td>\n",
       "      <td>-402.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.700000e+05</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-402</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126053</th>\n",
       "      <td>287903</td>\n",
       "      <td>5244116</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-185</td>\n",
       "      <td>0</td>\n",
       "      <td>1641.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>9.630000e+05</td>\n",
       "      <td>924759.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-49</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126052</th>\n",
       "      <td>287903</td>\n",
       "      <td>5244115</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-227</td>\n",
       "      <td>0</td>\n",
       "      <td>997.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>6.750000e+04</td>\n",
       "      <td>57816.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-49</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>637703</th>\n",
       "      <td>331339</td>\n",
       "      <td>6228355</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1698</td>\n",
       "      <td>0</td>\n",
       "      <td>-1526.0</td>\n",
       "      <td>-1515.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.933100e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1514</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1376434</th>\n",
       "      <td>360148</td>\n",
       "      <td>5386539</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1082</td>\n",
       "      <td>0</td>\n",
       "      <td>746.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.150000e+05</td>\n",
       "      <td>0.000</td>\n",
       "      <td>315000.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-606</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771559</th>\n",
       "      <td>360148</td>\n",
       "      <td>5386538</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1093</td>\n",
       "      <td>0</td>\n",
       "      <td>-442.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.500000e+03</td>\n",
       "      <td>-627.525</td>\n",
       "      <td>5127.525</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-606</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771560</th>\n",
       "      <td>360148</td>\n",
       "      <td>5386540</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1110</td>\n",
       "      <td>0</td>\n",
       "      <td>-988.0</td>\n",
       "      <td>-990.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1.709100e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-988</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1376436</th>\n",
       "      <td>360148</td>\n",
       "      <td>5386542</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1417</td>\n",
       "      <td>0</td>\n",
       "      <td>-1237.0</td>\n",
       "      <td>-915.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3.159000e+04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-912</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1376435</th>\n",
       "      <td>360148</td>\n",
       "      <td>5386541</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1880</td>\n",
       "      <td>0</td>\n",
       "      <td>-1698.0</td>\n",
       "      <td>-915.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3.149550e+04</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-912</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1376433</th>\n",
       "      <td>360148</td>\n",
       "      <td>5386537</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2848</td>\n",
       "      <td>0</td>\n",
       "      <td>-289.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7200.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.800000e+05</td>\n",
       "      <td>273761.145</td>\n",
       "      <td>81738.855</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-596</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1611962</th>\n",
       "      <td>367497</td>\n",
       "      <td>6688864</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-599</td>\n",
       "      <td>0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.335545e+05</td>\n",
       "      <td>51561.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-7</td>\n",
       "      <td>10593.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1359150</th>\n",
       "      <td>372321</td>\n",
       "      <td>6731953</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-28</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.0</td>\n",
       "      <td>-19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.250000e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-12</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1239189</th>\n",
       "      <td>372321</td>\n",
       "      <td>5918719</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2633</td>\n",
       "      <td>0</td>\n",
       "      <td>4671.0</td>\n",
       "      <td>-1527.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1.012500e+07</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Mortgage</td>\n",
       "      <td>-859</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1149267</th>\n",
       "      <td>409450</td>\n",
       "      <td>5608499</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-182</td>\n",
       "      <td>0</td>\n",
       "      <td>770.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>2.250000e+05</td>\n",
       "      <td>106038.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-36</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1149266</th>\n",
       "      <td>409450</td>\n",
       "      <td>5608498</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-530</td>\n",
       "      <td>0</td>\n",
       "      <td>678.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1.575000e+05</td>\n",
       "      <td>147145.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-32</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934675</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444292</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-554</td>\n",
       "      <td>0</td>\n",
       "      <td>-188.0</td>\n",
       "      <td>-188.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4.438710e+05</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-167</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934671</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444286</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1110</td>\n",
       "      <td>0</td>\n",
       "      <td>2584.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4.635000e+06</td>\n",
       "      <td>3745278.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Mortgage</td>\n",
       "      <td>-19</td>\n",
       "      <td>61897.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934670</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444285</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1356</td>\n",
       "      <td>0</td>\n",
       "      <td>836.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1.575000e+05</td>\n",
       "      <td>160002.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-1137</td>\n",
       "      <td>17208.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934674</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444291</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2002</td>\n",
       "      <td>0</td>\n",
       "      <td>-1698.0</td>\n",
       "      <td>-1698.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>9.882000e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1698</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705495</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444283</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2470</td>\n",
       "      <td>0</td>\n",
       "      <td>30907.0</td>\n",
       "      <td>-2043.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1.350000e+05</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-759</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934672</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444289</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2484</td>\n",
       "      <td>0</td>\n",
       "      <td>-2178.0</td>\n",
       "      <td>-2178.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>4.168800e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2178</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934673</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444290</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2517</td>\n",
       "      <td>0</td>\n",
       "      <td>-2213.0</td>\n",
       "      <td>-2213.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7.901550e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1990</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>934669</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444282</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2518</td>\n",
       "      <td>0</td>\n",
       "      <td>-2213.0</td>\n",
       "      <td>-2210.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>7.901550e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-995</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705496</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444284</td>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2541</td>\n",
       "      <td>0</td>\n",
       "      <td>-715.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>3.690000e+05</td>\n",
       "      <td>111492.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1137</td>\n",
       "      <td>8788.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705497</th>\n",
       "      <td>443868</td>\n",
       "      <td>5444287</td>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2722</td>\n",
       "      <td>0</td>\n",
       "      <td>-2417.0</td>\n",
       "      <td>-2538.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>8.266050e+04</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2538</td>\n",
       "      <td>0.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         SK_ID_CURR  SK_ID_BUREAU CREDIT_ACTIVE CREDIT_CURRENCY  DAYS_CREDIT  \\\n",
       "1439216      172665       6693683        Active      currency 1         -235   \n",
       "1439206      172665       6693672        Active      currency 1         -316   \n",
       "1439209      172665       6693675        Active      currency 1         -362   \n",
       "1439205      172665       6693671        Active      currency 1         -366   \n",
       "1695342      172665       6693670        Closed      currency 1         -420   \n",
       "1439215      172665       6693682        Closed      currency 1         -465   \n",
       "1439207      172665       6693673        Closed      currency 1         -508   \n",
       "1695343      172665       6693681        Closed      currency 1         -594   \n",
       "1439208      172665       6693674        Closed      currency 1        -1082   \n",
       "1439212      172665       6693678        Closed      currency 1        -1685   \n",
       "1439211      172665       6693677        Active      currency 1        -2293   \n",
       "1439213      172665       6693679        Active      currency 1        -2371   \n",
       "1439214      172665       6693680        Active      currency 1        -2373   \n",
       "1439210      172665       6693676        Closed      currency 1        -2553   \n",
       "325465       201208       5537173        Active      currency 1         -387   \n",
       "325466       201208       5537174        Closed      currency 1         -925   \n",
       "368454       201208       5537175        Closed      currency 1        -1471   \n",
       "126053       287903       5244116        Active      currency 1         -185   \n",
       "126052       287903       5244115        Active      currency 1         -227   \n",
       "637703       331339       6228355        Closed      currency 1        -1698   \n",
       "1376434      360148       5386539        Active      currency 1        -1082   \n",
       "771559       360148       5386538        Active      currency 1        -1093   \n",
       "771560       360148       5386540        Closed      currency 1        -1110   \n",
       "1376436      360148       5386542        Closed      currency 1        -1417   \n",
       "1376435      360148       5386541        Closed      currency 1        -1880   \n",
       "1376433      360148       5386537        Active      currency 1        -2848   \n",
       "1611962      367497       6688864        Active      currency 1         -599   \n",
       "1359150      372321       6731953        Closed      currency 1          -28   \n",
       "1239189      372321       5918719        Closed      currency 1        -2633   \n",
       "1149267      409450       5608499        Active      currency 1         -182   \n",
       "1149266      409450       5608498        Active      currency 1         -530   \n",
       "934675       443868       5444292        Closed      currency 1         -554   \n",
       "934671       443868       5444286        Active      currency 1        -1110   \n",
       "934670       443868       5444285        Active      currency 1        -1356   \n",
       "934674       443868       5444291        Closed      currency 1        -2002   \n",
       "705495       443868       5444283        Closed      currency 1        -2470   \n",
       "934672       443868       5444289        Closed      currency 1        -2484   \n",
       "934673       443868       5444290        Closed      currency 1        -2517   \n",
       "934669       443868       5444282        Closed      currency 1        -2518   \n",
       "705496       443868       5444284        Active      currency 1        -2541   \n",
       "705497       443868       5444287        Closed      currency 1        -2722   \n",
       "\n",
       "         CREDIT_DAY_OVERDUE  DAYS_CREDIT_ENDDATE  DAYS_ENDDATE_FACT  \\\n",
       "1439216                   0                863.0                NaN   \n",
       "1439206                   0                -12.0                NaN   \n",
       "1439209                   0               1464.0                NaN   \n",
       "1439205                   0                730.0                NaN   \n",
       "1695342                   0               -145.0             -356.0   \n",
       "1439215                   0               -373.0             -373.0   \n",
       "1439207                   0               1318.0             -351.0   \n",
       "1695343                   0                228.0             -380.0   \n",
       "1439208                   0               -351.0             -381.0   \n",
       "1439212                   0              -1501.0            -1085.0   \n",
       "1439211                   0              -1928.0                NaN   \n",
       "1439213                   0                225.0                NaN   \n",
       "1439214                   0               -566.0                NaN   \n",
       "1439210                   0              -2201.0            -2187.0   \n",
       "325465                    0                711.0                NaN   \n",
       "325466                    0               -743.0             -743.0   \n",
       "368454                    0               -402.0             -402.0   \n",
       "126053                    0               1641.0                NaN   \n",
       "126052                    0                997.0                NaN   \n",
       "637703                    0              -1526.0            -1515.0   \n",
       "1376434                   0                746.0                NaN   \n",
       "771559                    0               -442.0                NaN   \n",
       "771560                    0               -988.0             -990.0   \n",
       "1376436                   0              -1237.0             -915.0   \n",
       "1376435                   0              -1698.0             -915.0   \n",
       "1376433                   0               -289.0                NaN   \n",
       "1611962                   0                126.0                NaN   \n",
       "1359150                   0                -12.0              -19.0   \n",
       "1239189                   0               4671.0            -1527.0   \n",
       "1149267                   0                770.0                NaN   \n",
       "1149266                   0                678.0                NaN   \n",
       "934675                    0               -188.0             -188.0   \n",
       "934671                    0               2584.0                NaN   \n",
       "934670                    0                836.0                NaN   \n",
       "934674                    0              -1698.0            -1698.0   \n",
       "705495                    0              30907.0            -2043.0   \n",
       "934672                    0              -2178.0            -2178.0   \n",
       "934673                    0              -2213.0            -2213.0   \n",
       "934669                    0              -2213.0            -2210.0   \n",
       "705496                    0               -715.0                NaN   \n",
       "705497                    0              -2417.0            -2538.0   \n",
       "\n",
       "         AMT_CREDIT_MAX_OVERDUE  CNT_CREDIT_PROLONG  AMT_CREDIT_SUM  \\\n",
       "1439216                     0.0                   0    1.237500e+06   \n",
       "1439206                     0.0                   0    9.067050e+04   \n",
       "1439209                     NaN                   0    2.452500e+06   \n",
       "1439205                     0.0                   0    2.250000e+05   \n",
       "1695342                     0.0                   0    7.650000e+04   \n",
       "1439215                     0.0                   0    1.141819e+05   \n",
       "1439207                     NaN                   0    1.107000e+06   \n",
       "1695343                     0.0                   0    3.645000e+05   \n",
       "1439208                     NaN                   0    1.538550e+05   \n",
       "1439212                     NaN                   0    5.079600e+04   \n",
       "1439211                     NaN                   0    4.500000e+04   \n",
       "1439213                     NaN                   0    6.300000e+05   \n",
       "1439214                     0.0                   1    6.300000e+05   \n",
       "1439210                     NaN                   0    2.636550e+04   \n",
       "325465                      0.0                   0    2.700000e+05   \n",
       "325466                      0.0                   0    3.523500e+04   \n",
       "368454                      0.0                   0    2.700000e+05   \n",
       "126053                      NaN                   0    9.630000e+05   \n",
       "126052                      NaN                   0    6.750000e+04   \n",
       "637703                      NaN                   0    2.933100e+04   \n",
       "1376434                     0.0                   0    3.150000e+05   \n",
       "771559                      0.0                   0    4.500000e+03   \n",
       "771560                      NaN                   0    1.709100e+04   \n",
       "1376436                     NaN                   0    3.159000e+04   \n",
       "1376435                     NaN                   0    3.149550e+04   \n",
       "1376433                  7200.0                   0    1.800000e+05   \n",
       "1611962                     NaN                   0    2.335545e+05   \n",
       "1359150                     NaN                   0    2.250000e+04   \n",
       "1239189                     NaN                   0    1.012500e+07   \n",
       "1149267                     NaN                   0    2.250000e+05   \n",
       "1149266                     NaN                   0    1.575000e+05   \n",
       "934675                      NaN                   0    4.438710e+05   \n",
       "934671                      NaN                   0    4.635000e+06   \n",
       "934670                      NaN                   0    1.575000e+05   \n",
       "934674                      NaN                   0    9.882000e+04   \n",
       "705495                      NaN                   0    1.350000e+05   \n",
       "934672                      NaN                   0    4.168800e+04   \n",
       "934673                      NaN                   0    7.901550e+04   \n",
       "934669                      NaN                   0    7.901550e+04   \n",
       "705496                      NaN                   0    3.690000e+05   \n",
       "705497                      NaN                   0    8.266050e+04   \n",
       "\n",
       "         AMT_CREDIT_SUM_DEBT  AMT_CREDIT_SUM_LIMIT  AMT_CREDIT_SUM_OVERDUE  \\\n",
       "1439216          1095934.500                 0.000                     0.0   \n",
       "1439206                0.000                 0.000                     0.0   \n",
       "1439209          1871662.500                 0.000                     0.0   \n",
       "1439205             -450.000            225450.000                     0.0   \n",
       "1695342                0.000                 0.000                     0.0   \n",
       "1439215                0.000                 0.000                     0.0   \n",
       "1439207                0.000                 0.000                     0.0   \n",
       "1695343                0.000                 0.000                     0.0   \n",
       "1439208                0.000                 0.000                     0.0   \n",
       "1439212                0.000                   NaN                     0.0   \n",
       "1439211                  NaN                   NaN                     0.0   \n",
       "1439213           586111.500                   NaN                     0.0   \n",
       "1439214           511164.000             43888.500                     0.0   \n",
       "1439210                  NaN                   NaN                     0.0   \n",
       "325465            194998.500                 0.000                     0.0   \n",
       "325466                 0.000                 0.000                     0.0   \n",
       "368454                 0.000                 0.000                     0.0   \n",
       "126053            924759.000                 0.000                     0.0   \n",
       "126052             57816.000                 0.000                     0.0   \n",
       "637703                 0.000                 0.000                     0.0   \n",
       "1376434                0.000            315000.000                     0.0   \n",
       "771559              -627.525              5127.525                     0.0   \n",
       "771560                 0.000                   NaN                     0.0   \n",
       "1376436                  NaN                   NaN                     0.0   \n",
       "1376435                  NaN                   NaN                     0.0   \n",
       "1376433           273761.145             81738.855                     0.0   \n",
       "1611962            51561.000                 0.000                     0.0   \n",
       "1359150                0.000                 0.000                     0.0   \n",
       "1239189                0.000                 0.000                     0.0   \n",
       "1149267           106038.000                   NaN                     0.0   \n",
       "1149266           147145.500                 0.000                     0.0   \n",
       "934675                 0.000                   NaN                     0.0   \n",
       "934671           3745278.000                 0.000                     0.0   \n",
       "934670            160002.000                 0.000                     0.0   \n",
       "934674                 0.000                   NaN                     0.0   \n",
       "705495                 0.000                 0.000                     0.0   \n",
       "934672                 0.000                   NaN                     0.0   \n",
       "934673                 0.000                   NaN                     0.0   \n",
       "934669                 0.000                 0.000                     0.0   \n",
       "705496            111492.000                 0.000                     0.0   \n",
       "705497                 0.000                   NaN                     0.0   \n",
       "\n",
       "             CREDIT_TYPE  DAYS_CREDIT_UPDATE  AMT_ANNUITY  \n",
       "1439216  Consumer credit                 -48          NaN  \n",
       "1439206  Consumer credit                -232          NaN  \n",
       "1439209  Consumer credit                 -61          NaN  \n",
       "1439205      Credit card                -232          NaN  \n",
       "1695342  Consumer credit                -332          NaN  \n",
       "1439215  Consumer credit                -370          NaN  \n",
       "1439207  Consumer credit                -334          NaN  \n",
       "1695343  Consumer credit                -376          NaN  \n",
       "1439208  Consumer credit                -381          NaN  \n",
       "1439212  Consumer credit               -1085          NaN  \n",
       "1439211  Consumer credit               -1935          NaN  \n",
       "1439213      Credit card                 -26          NaN  \n",
       "1439214      Credit card                 -26          NaN  \n",
       "1439210  Consumer credit               -2187          NaN  \n",
       "325465   Consumer credit                 -55      7297.29  \n",
       "325466   Consumer credit                -737          NaN  \n",
       "368454   Consumer credit                -402          NaN  \n",
       "126053   Consumer credit                 -49          NaN  \n",
       "126052       Credit card                 -49          NaN  \n",
       "637703   Consumer credit               -1514          NaN  \n",
       "1376434      Credit card                -606          NaN  \n",
       "771559       Credit card                -606          NaN  \n",
       "771560   Consumer credit                -988          NaN  \n",
       "1376436  Consumer credit                -912          NaN  \n",
       "1376435  Consumer credit                -912          NaN  \n",
       "1376433      Credit card                -596          NaN  \n",
       "1611962  Consumer credit                  -7     10593.00  \n",
       "1359150  Consumer credit                 -12         0.00  \n",
       "1239189         Mortgage                -859         0.00  \n",
       "1149267      Credit card                 -36          NaN  \n",
       "1149266      Credit card                 -32          NaN  \n",
       "934675   Consumer credit                -167         0.00  \n",
       "934671          Mortgage                 -19     61897.50  \n",
       "934670       Credit card               -1137     17208.00  \n",
       "934674   Consumer credit               -1698         0.00  \n",
       "705495       Credit card                -759         0.00  \n",
       "934672   Consumer credit               -2178         0.00  \n",
       "934673   Consumer credit               -1990         0.00  \n",
       "934669   Consumer credit                -995         0.00  \n",
       "705496   Consumer credit               -1137      8788.50  \n",
       "705497   Consumer credit               -2538         0.00  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp = df[df.SK_ID_CURR.isin(np.random.choice(ids, size=9))]\n",
    "tmp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
